public class Spreadsheet : DocumentPublic Class Spreadsheet
Inherits Document| Spreadsheet | Initializes a new instance of the Spreadsheet class |
| Spreadsheet(Stream) | Initializes a new instance of the Spreadsheet class |
| Spreadsheet(String) | Initializes a new instance of the Spreadsheet class |
| Clone | |
| Equals | (Inherited from Object) |
| Finalize | (Inherited from Object) |
| Find(String) |
Returns all occurrences of the specified text in the whole document, including
tables, headers, footers, notes, annotations, text boxes and shapes.
(Inherited from Document) |
| Find(String, FindOptions) |
Returns all occurrences of the specified text.
(Inherited from Document) |
| FindElementsT |
Returns all content elements of the specified type, for example all images or
all tables, from the whole document.
(Inherited from Document) |
| FindElementsT(PredicateT) |
Returns all content elements of the specified type which match the specified condition.
(Inherited from Document) |
| FindElementsT(PredicateT, SearchScope) |
Returns all content elements of the specified type which match the specified condition.
(Inherited from Document) |
| FindFirst(String) |
Returns the first occurrence of the specified text or null if the text was not found.
(Inherited from Document) |
| FindFirst(String, FindOptions) |
Returns the first occurrence of the specified text or null if the text was not found.
(Inherited from Document) |
| GetAttributedTexts | (Inherited from Document) |
| GetBytes | (Overrides DocumentGetBytes) |
| GetContentElements | (Overrides DocumentGetContentElements) |
| GetCsv | Returns the content of all tables as comma separated values. Each table is preceded by an empty line and its name, the cells of a row are separated by a comma and the rows are separated by a line break. A field which contains a comma, a quotation mark or a line break is enclosed in quotation marks and an embedded quotation mark is doubled, as specified by RFC 4180. The empty cells and rows a table is padded with are not written. |
| GetFields | (Inherited from Document) |
| GetHashCode | (Inherited from Object) |
| GetHeadings | (Inherited from Document) |
| GetHtml |
Converts the document to HTML format.
(Overrides DocumentGetHtml) |
| GetImages | (Inherited from Document) |
| GetLists | (Inherited from Document) |
| GetParagraphs | (Inherited from Document) |
| GetSections | (Inherited from Document) |
| GetStream | (Overrides DocumentGetStream) |
| GetTables | (Inherited from Document) |
| GetText |
Returns the plain text of the whole document.
(Inherited from Document) |
| GetTexts | (Inherited from Document) |
| GetType | (Inherited from Object) |
| MemberwiseClone | (Inherited from Object) |
| Open(Stream) | (Overrides DocumentOpen(Stream)) |
| Open(String) | (Overrides DocumentOpen(String)) |
| Remove |
Removes the specified content element from the document.
(Inherited from Document) |
| RenameStyle | |
| Replace(IContentElement, IContentElement) |
Replaces the specified content element, for example a span, a paragraph or a
table, with another content element. The properties of the replaced element are
preserved if the new element has no own properties.
(Inherited from Document) |
| Replace(IListString, IListString) |
Replaces all occurrences of the specified oldText with newText.
(Inherited from Document) |
| Replace(Image, String) |
Replaces the image of the specified image element. The size, the position and
all other properties of the frame remain unchanged.
(Inherited from Document) |
| Replace(String, AttributedText) |
Replaces all occurrences of the specified text with a copy of the specified
span. The text before and after the replaced text keeps its formatting.
(Inherited from Document) |
| Replace(String, IParagraphContent) |
Replaces all occurrences of the specified text with a copy of the specified
content, for example an image, a tab, a line break, a field or a hyperlink.
(Inherited from Document) |
| Replace(String, String) |
Replaces all occurrences of the specified oldText with newText in the whole
document. The paragraphs, their styles and all other content of the paragraphs
remain unchanged.
(Inherited from Document) |
| Replace(IContentElement, IContentElement, FindOptions) |
Replaces the specified content element with another content element.
(Inherited from Document) |
| Replace(IListString, IListString, FindOptions) |
Replaces all occurrences of the specified oldText with newText.
(Inherited from Document) |
| Replace(Image, String, Byte) |
Replaces the image of the specified image element. The size, the position and
all other properties of the frame remain unchanged.
(Inherited from Document) |
| Replace(String, AttributedText, FindOptions) |
Replaces all occurrences of the specified text with a copy of the specified span.
(Inherited from Document) |
| Replace(String, IParagraphContent, FindOptions) |
Replaces all occurrences of the specified text with a copy of the specified content.
(Inherited from Document) |
| Replace(String, IListAttributedText, FindOptions) |
Replaces all occurrences of the specified text with copies of the specified spans.
(Inherited from Document) |
| Replace(String, IListIParagraphContent, FindOptions) |
Replaces all occurrences of the specified text with copies of the specified content.
(Inherited from Document) |
| Replace(String, String, FindOptions) |
Replaces all occurrences of the specified oldText with newText.
(Inherited from Document) |
| Save(Stream) | (Overrides DocumentSave(Stream)) |
| Save(String) | (Overrides DocumentSave(String)) |
| Save(String, Boolean) | (Overrides DocumentSave(String, Boolean)) |
| SaveAsHtml(Stream) |
Saves the document in HTML format.
(Overrides DocumentSaveAsHtml(Stream)) |
| SaveAsHtml(String) |
Saves the document in HTML format.
(Overrides DocumentSaveAsHtml(String)) |
| SaveAsHtml(String, Boolean) |
Saves the document in HTML format.
(Overrides DocumentSaveAsHtml(String, Boolean)) |
| ToString | (Inherited from Object) |
| Validate | Checks the spreadsheet for the things that make an .ods unusable or non-conforming, and returns what it finds. An empty list means nothing known is wrong. This is NOT a schema validator - OpenDocument is defined in RELAX NG and validating against it needs the schema itself; see tools/odf-validate. This knows the invariants the object model can express, and nothing beyond them. |